Pandas Profiling Report

Dataset statistics

Number of variables	37
Number of observations	31
Missing cells	238
Missing cells (%)	20.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.9 KiB
Average record size in memory	1.0 KiB

Variable types

Categorical	16
Text	2
Numeric	14
DateTime	5

Alerts

`active_ingredient` has constant value ""	Constant
`atc` has constant value ""	Constant
`pack_strength` has constant value ""	Constant
`price_participants_24` has constant value ""	Constant
`price_participants_4` has constant value ""	Constant
`price_participants_5` has constant value ""	Constant
`price_participants_8` has constant value ""	Constant
`sku` has constant value ""	Constant
`contract_id` is highly overall correlated with `price_participants_16` and 2 other fields	High correlation
`contract_type` is highly overall correlated with `price_participants_6` and 1 other fields	High correlation
`duration` is highly overall correlated with `duration_total_new` and 2 other fields	High correlation
`duration_ext` is highly overall correlated with `outcome` and 2 other fields	High correlation
`duration_total_new` is highly overall correlated with `duration` and 1 other fields	High correlation
`maximum_price_allowed` is highly overall correlated with `price_participants_16` and 7 other fields	High correlation
`outcome` is highly overall correlated with `duration_ext` and 5 other fields	High correlation
`participants_no` is highly overall correlated with `price_participants_16` and 4 other fields	High correlation
`price_participants_16` is highly overall correlated with `contract_id` and 7 other fields	High correlation
`price_participants_19` is highly overall correlated with `maximum_price_allowed` and 2 other fields	High correlation
`price_participants_23` is highly overall correlated with `maximum_price_allowed` and 2 other fields	High correlation
`price_participants_6` is highly overall correlated with `contract_type` and 11 other fields	High correlation
`price_participants_7` is highly overall correlated with `contract_id` and 17 other fields	High correlation
`quantity_ext` is highly overall correlated with `price_participants_6` and 4 other fields	High correlation
`quantity_monthly` is highly overall correlated with `price_participants_6` and 4 other fields	High correlation
`quantity_total` is highly overall correlated with `price_participants_6` and 4 other fields	High correlation
`quantity_yearly` is highly overall correlated with `price_participants_6` and 4 other fields	High correlation
`second_place` is highly overall correlated with `maximum_price_allowed` and 4 other fields	High correlation
`second_place_outcome` is highly overall correlated with `duration_ext` and 7 other fields	High correlation
`second_place_price` is highly overall correlated with `maximum_price_allowed` and 3 other fields	High correlation
`winner` is highly overall correlated with `contract_id` and 5 other fields	High correlation
`winner_price` is highly overall correlated with `maximum_price_allowed` and 4 other fields	High correlation
`outcome` is highly imbalanced (79.4%)	Imbalance
`price_participants_16` has 9 (29.0%) missing values	Missing
`price_participants_19` has 17 (54.8%) missing values	Missing
`price_participants_23` has 19 (61.3%) missing values	Missing
`price_participants_24` has 30 (96.8%) missing values	Missing
`price_participants_4` has 30 (96.8%) missing values	Missing
`price_participants_5` has 30 (96.8%) missing values	Missing
`price_participants_6` has 28 (90.3%) missing values	Missing
`price_participants_7` has 29 (93.5%) missing values	Missing
`price_participants_8` has 30 (96.8%) missing values	Missing
`second_place_price` has 16 (51.6%) missing values	Missing
`contract_id` is uniformly distributed	Uniform
`price_participants_7` is uniformly distributed	Uniform
`contract_id` has unique values	Unique
`published_date` has unique values	Unique
`quantity_total` has unique values	Unique
`quantity_monthly` has unique values	Unique
`quantity_yearly` has unique values	Unique
`quantity_ext` has unique values	Unique
`duration_ext` has 7 (22.6%) zeros	Zeros

Reproduction

Analysis started	2024-05-05 12:16:09.480028
Analysis finished	2024-05-05 12:16:39.108808
Duration	29.63 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

active_ingredient
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	2.2 KiB

molecule_x	31

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	310
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	molecule_x
2nd row	molecule_x
3rd row	molecule_x
4th row	molecule_x
5th row	molecule_x

Common Values

Value	Count	Frequency (%)
molecule_x	31	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
molecule_x	31	100.0%

Most occurring characters

Value	Count	Frequency (%)
l	62	20.0%
e	62	20.0%
m	31	10.0%
o	31	10.0%
c	31	10.0%
u	31	10.0%
_	31	10.0%
x	31	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	310	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	62	20.0%
e	62	20.0%
m	31	10.0%
o	31	10.0%
c	31	10.0%
u	31	10.0%
_	31	10.0%
x	31	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	310	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	62	20.0%
e	62	20.0%
m	31	10.0%
o	31	10.0%
c	31	10.0%
u	31	10.0%
_	31	10.0%
x	31	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	310	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	62	20.0%
e	62	20.0%
m	31	10.0%
o	31	10.0%
c	31	10.0%
u	31	10.0%
_	31	10.0%
x	31	10.0%

atc
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

C07AB07	31

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	217
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C07AB07
2nd row	C07AB07
3rd row	C07AB07
4th row	C07AB07
5th row	C07AB07

Common Values

Value	Count	Frequency (%)
C07AB07	31	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c07ab07	31	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	62	28.6%
7	62	28.6%
C	31	14.3%
A	31	14.3%
B	31	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	217	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	62	28.6%
7	62	28.6%
C	31	14.3%
A	31	14.3%
B	31	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	217	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	62	28.6%
7	62	28.6%
C	31	14.3%
A	31	14.3%
B	31	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	217	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	62	28.6%
7	62	28.6%
C	31	14.3%
A	31	14.3%
B	31	14.3%

buyer
Text

Distinct	19
Distinct (%)	61.3%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

Length

Max length	8
Median length	7
Mean length	7.483871
Min length	7

Characters and Unicode

Total characters	232
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	32.3%

Sample

1st row	buyer_1
2nd row	buyer_2
3rd row	buyer_3
4th row	buyer_4
5th row	buyer_5

Value	Count	Frequency (%)
buyer_8	3	9.7%
buyer_11	3	9.7%
buyer_2	3	9.7%
buyer_19	2	6.5%
buyer_3	2	6.5%
buyer_5	2	6.5%
buyer_7	2	6.5%
buyer_16	2	6.5%
buyer_12	2	6.5%
buyer_13	1	3.2%
Other values (9)	9	29.0%

Most occurring characters

Value	Count	Frequency (%)
b	31	13.4%
u	31	13.4%
y	31	13.4%
e	31	13.4%
r	31	13.4%
_	31	13.4%
1	19	8.2%
2	5	2.2%
8	4	1.7%
9	3	1.3%
Other values (6)	15	6.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	232	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
b	31	13.4%
u	31	13.4%
y	31	13.4%
e	31	13.4%
r	31	13.4%
_	31	13.4%
1	19	8.2%
2	5	2.2%
8	4	1.7%
9	3	1.3%
Other values (6)	15	6.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	232	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
b	31	13.4%
u	31	13.4%
y	31	13.4%
e	31	13.4%
r	31	13.4%
_	31	13.4%
1	19	8.2%
2	5	2.2%
8	4	1.7%
9	3	1.3%
Other values (6)	15	6.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	232	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
b	31	13.4%
u	31	13.4%
y	31	13.4%
e	31	13.4%
r	31	13.4%
_	31	13.4%
1	19	8.2%
2	5	2.2%
8	4	1.7%
9	3	1.3%
Other values (6)	15	6.5%

contract_id
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	1
5-th percentile	2.5
Q1	8.5
median	16
Q3	23.5
95-th percentile	29.5
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.0921211
Coefficient of variation (CV)	0.56825757
Kurtosis	-1.2
Mean	16
Median Absolute Deviation (MAD)	8
Skewness	0
Sum	496
Variance	82.666667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	1	3.2%
17	1	3.2%
30	1	3.2%
29	1	3.2%
28	1	3.2%
27	1	3.2%
26	1	3.2%
25	1	3.2%
24	1	3.2%
23	1	3.2%
Other values (21)	21	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	3.2%
2	1	3.2%
3	1	3.2%
4	1	3.2%
5	1	3.2%
6	1	3.2%
7	1	3.2%
8	1	3.2%
9	1	3.2%
10	1	3.2%

Value	Count	Frequency (%)
31	1	3.2%
30	1	3.2%
29	1	3.2%
28	1	3.2%
27	1	3.2%
26	1	3.2%
25	1	3.2%
24	1	3.2%
23	1	3.2%
22	1	3.2%

contract_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

regional	24
multi-region	6
wide area	1

Length

Max length	12
Median length	8
Mean length	8.8064516
Min length	8

Characters and Unicode

Total characters	273
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	3.2%

Sample

1st row	regional
2nd row	wide area
3rd row	regional
4th row	regional
5th row	regional

Common Values

Value	Count	Frequency (%)
regional	24	77.4%
multi-region	6	19.4%
wide area	1	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
regional	24	75.0%
multi-region	6	18.8%
wide	1	3.1%
area	1	3.1%

Most occurring characters

Value	Count	Frequency (%)
i	37	13.6%
e	32	11.7%
r	31	11.4%
g	30	11.0%
o	30	11.0%
n	30	11.0%
l	30	11.0%
a	26	9.5%
m	6	2.2%
u	6	2.2%
Other values (5)	15	5.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	273	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	37	13.6%
e	32	11.7%
r	31	11.4%
g	30	11.0%
o	30	11.0%
n	30	11.0%
l	30	11.0%
a	26	9.5%
m	6	2.2%
u	6	2.2%
Other values (5)	15	5.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	273	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	37	13.6%
e	32	11.7%
r	31	11.4%
g	30	11.0%
o	30	11.0%
n	30	11.0%
l	30	11.0%
a	26	9.5%
m	6	2.2%
u	6	2.2%
Other values (5)	15	5.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	273	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	37	13.6%
e	32	11.7%
r	31	11.4%
g	30	11.0%
o	30	11.0%
n	30	11.0%
l	30	11.0%
a	26	9.5%
m	6	2.2%
u	6	2.2%
Other values (5)	15	5.5%

duration
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	19.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.419355

Minimum	12
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	12
5-th percentile	12
Q1	24
median	36
Q3	37.5
95-th percentile	48
Maximum	49
Range	37
Interquartile range (IQR)	13.5

Descriptive statistics

Standard deviation	11.552126
Coefficient of variation (CV)	0.34567172
Kurtosis	-0.53357719
Mean	33.419355
Median Absolute Deviation (MAD)	12
Skewness	-0.4979471
Sum	1036
Variance	133.45161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
36	13	41.9%
48	6	19.4%
24	6	19.4%
12	4	12.9%
39	1	3.2%
49	1	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	4	12.9%
24	6	19.4%
36	13	41.9%
39	1	3.2%
48	6	19.4%
49	1	3.2%

Value	Count	Frequency (%)
49	1	3.2%
48	6	19.4%
39	1	3.2%
36	13	41.9%
24	6	19.4%
12	4	12.9%

end_date_extension
Date

Distinct	28
Distinct (%)	90.3%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Minimum	2015-03-31 00:00:00
Maximum	2027-03-30 00:00:00

Histogram

Histogram with fixed size bins (bins=28)

maximum_price_allowed
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	87.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.088368841

Minimum	1 × 10^-5
Maximum	0.99931561
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	1 × 10^-5
5-th percentile	1 × 10^-5
Q1	0.01225
median	0.0242
Q3	0.06
95-th percentile	0.47971424
Maximum	0.99931561
Range	0.99930561
Interquartile range (IQR)	0.04775

Descriptive statistics

Standard deviation	0.22771038
Coefficient of variation (CV)	2.5768175
Kurtosis	12.670157
Mean	0.088368841
Median Absolute Deviation (MAD)	0.01885
Skewness	3.6761071
Sum	2.7394341
Variance	0.051852018
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
0.03929	2	6.5%
0.07	2	6.5%
0.0004	1	3.2%
0.9993156096	1	3.2%
0.02679	1	3.2%
0.034	1	3.2%
0.01571	1	3.2%
0.0122	1	3.2%
0.018	1	3.2%
Other values (17)	17	54.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
5 × 10^-5	1	3.2%
0.0001	1	3.2%
0.0004	1	3.2%
0.007	1	3.2%
0.0122	1	3.2%
0.0123	1	3.2%
0.0125	1	3.2%
0.01571	1	3.2%
0.01607	1	3.2%

Value	Count	Frequency (%)
0.9993156096	1	3.2%
0.8665684756	1	3.2%
0.09286	1	3.2%
0.08	1	3.2%
0.075	1	3.2%
0.07071	1	3.2%
0.07	2	6.5%
0.05	1	3.2%
0.04305	1	3.2%
0.03929	2	6.5%

outcome
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

won	30
lost	1

Length

Max length	4
Median length	3
Mean length	3.0322581
Min length	3

Characters and Unicode

Total characters	94
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	3.2%

Sample

1st row	won
2nd row	won
3rd row	won
4th row	won
5th row	won

Common Values

Value	Count	Frequency (%)
won	30	96.8%
lost	1	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
won	30	96.8%
lost	1	3.2%

Most occurring characters

Value	Count	Frequency (%)
o	31	33.0%
w	30	31.9%
n	30	31.9%
l	1	1.1%
s	1	1.1%
t	1	1.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	94	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	31	33.0%
w	30	31.9%
n	30	31.9%
l	1	1.1%
s	1	1.1%
t	1	1.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	94	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	31	33.0%
w	30	31.9%
n	30	31.9%
l	1	1.1%
s	1	1.1%
t	1	1.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	94	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	31	33.0%
w	30	31.9%
n	30	31.9%
l	1	1.1%
s	1	1.1%
t	1	1.1%

pack_strength
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

10mg	31

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	124
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10mg
2nd row	10mg
3rd row	10mg
4th row	10mg
5th row	10mg

Common Values

Value	Count	Frequency (%)
10mg	31	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
10mg	31	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	31	25.0%
0	31	25.0%
m	31	25.0%
g	31	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	124	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	31	25.0%
0	31	25.0%
m	31	25.0%
g	31	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	124	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	31	25.0%
0	31	25.0%
m	31	25.0%
g	31	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	124	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	31	25.0%
0	31	25.0%
m	31	25.0%
g	31	25.0%

participants_no
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

1	16
2	7
3	5
4	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	31
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

Most occurring characters

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	16	51.6%
2	7	22.6%
3	5	16.1%
4	3	9.7%

price_participants_16
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	15
Distinct (%)	68.2%
Missing	9
Missing (%)	29.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.026392273

Minimum	1 × 10^-5
Maximum	0.08
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	1 × 10^-5
5-th percentile	1 × 10^-5
Q1	0.00205
median	0.02
Q3	0.0397875
95-th percentile	0.07
Maximum	0.08
Range	0.07999
Interquartile range (IQR)	0.0377375

Descriptive statistics

Standard deviation	0.026162796
Coefficient of variation (CV)	0.99130516
Kurtosis	-0.43044088
Mean	0.026392273
Median Absolute Deviation (MAD)	0.01975
Skewness	0.87848741
Sum	0.58063
Variance	0.0006844919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
0.07	3	9.7%
0.02	3	9.7%
0.025	2	6.5%
0.0004	1	3.2%
0.007	1	3.2%
0.014	1	3.2%
0.019	1	3.2%
0.03	1	3.2%
0.0001	1	3.2%
Other values (5)	5	16.1%
(Missing)	9	29.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
5 × 10^-5	1	3.2%
0.0001	1	3.2%
0.0004	1	3.2%
0.007	1	3.2%
0.014	1	3.2%
0.017	1	3.2%
0.019	1	3.2%
0.02	3	9.7%
0.025	2	6.5%

Value	Count	Frequency (%)
0.08	1	3.2%
0.07	3	9.7%
0.05	1	3.2%
0.04305	1	3.2%
0.03	1	3.2%
0.025	2	6.5%
0.02	3	9.7%
0.019	1	3.2%
0.017	1	3.2%
0.014	1	3.2%

price_participants_19
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	12
Distinct (%)	85.7%
Missing	17
Missing (%)	54.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.079168463

Minimum	0.0122
Maximum	0.86656848
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	0.0122
5-th percentile	0.012265
Q1	0.015
median	0.016965
Q3	0.019875
95-th percentile	0.32604897
Maximum	0.86656848
Range	0.85436848
Interquartile range (IQR)	0.004875

Descriptive statistics

Standard deviation	0.22674316
Coefficient of variation (CV)	2.8640591
Kurtosis	13.964806
Mean	0.079168463
Median Absolute Deviation (MAD)	0.00275
Skewness	3.7351411
Sum	1.1083585
Variance	0.051412459
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0.01786	2	6.5%
0.015	2	6.5%
0.8665684756	1	3.2%
0.01607	1	3.2%
0.0125	1	3.2%
0.035	1	3.2%
0.0205	1	3.2%
0.0123	1	3.2%
0.018	1	3.2%
0.0122	1	3.2%
Other values (2)	2	6.5%
(Missing)	17	54.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0122	1	3.2%
0.0123	1	3.2%
0.0125	1	3.2%
0.015	2	6.5%
0.0155	1	3.2%
0.01607	1	3.2%
0.01786	2	6.5%
0.018	1	3.2%
0.0205	1	3.2%
0.034	1	3.2%

Value	Count	Frequency (%)
0.8665684756	1	3.2%
0.035	1	3.2%
0.034	1	3.2%
0.0205	1	3.2%
0.018	1	3.2%
0.01786	2	6.5%
0.01607	1	3.2%
0.0155	1	3.2%
0.015	2	6.5%
0.0125	1	3.2%

price_participants_23
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	10
Distinct (%)	83.3%
Missing	19
Missing (%)	61.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.049135

Minimum	0.01571
Maximum	0.09286
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	0.01571
5-th percentile	0.020231
Q1	0.036165
median	0.0414
Q3	0.0658375
95-th percentile	0.0806775
Maximum	0.09286
Range	0.07715
Interquartile range (IQR)	0.0296725

Descriptive statistics

Standard deviation	0.02298384
Coefficient of variation (CV)	0.46776921
Kurtosis	-0.61318865
Mean	0.049135
Median Absolute Deviation (MAD)	0.02059
Skewness	0.36979026
Sum	0.58962
Variance	0.00052825692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.06511	2	6.5%
0.03929	2	6.5%
0.07071	1	3.2%
0.04066	1	3.2%
0.04214	1	3.2%
0.06802	1	3.2%
0.01571	1	3.2%
0.02393	1	3.2%
0.02679	1	3.2%
0.09286	1	3.2%
(Missing)	19	61.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01571	1	3.2%
0.02393	1	3.2%
0.02679	1	3.2%
0.03929	2	6.5%
0.04066	1	3.2%
0.04214	1	3.2%
0.06511	2	6.5%
0.06802	1	3.2%
0.07071	1	3.2%
0.09286	1	3.2%

Value	Count	Frequency (%)
0.09286	1	3.2%
0.07071	1	3.2%
0.06802	1	3.2%
0.06511	2	6.5%
0.04214	1	3.2%
0.04066	1	3.2%
0.03929	2	6.5%
0.02679	1	3.2%
0.02393	1	3.2%
0.01571	1	3.2%

price_participants_24
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	30
Missing (%)	96.8%
Memory size	1.1 KiB

0.075	1

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	0.075

Common Values

Value	Count	Frequency (%)
0.075	1	3.2%
(Missing)	30	96.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.075	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
7	1	20.0%
5	1	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
7	1	20.0%
5	1	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
7	1	20.0%
5	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
7	1	20.0%
5	1	20.0%

price_participants_4
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	30
Missing (%)	96.8%
Memory size	1.1 KiB

0.0242	1

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	6
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	0.0242

Common Values

Value	Count	Frequency (%)
0.0242	1	3.2%
(Missing)	30	96.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0242	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2	33.3%
2	2	33.3%
.	1	16.7%
4	1	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2	33.3%
2	2	33.3%
.	1	16.7%
4	1	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2	33.3%
2	2	33.3%
.	1	16.7%
4	1	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2	33.3%
2	2	33.3%
.	1	16.7%
4	1	16.7%

price_participants_5
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	30
Missing (%)	96.8%
Memory size	1.1 KiB

0.08	1

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	0.08

Common Values

Value	Count	Frequency (%)
0.08	1	3.2%
(Missing)	30	96.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.08	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2	50.0%
.	1	25.0%
8	1	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2	50.0%
.	1	25.0%
8	1	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2	50.0%
.	1	25.0%
8	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2	50.0%
.	1	25.0%
8	1	25.0%

price_participants_6
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	66.7%
Missing	28
Missing (%)	90.3%
Memory size	1.2 KiB

0.034	2
0.01699	1

Length

Max length	7
Median length	5
Mean length	5.6666667
Min length	5

Characters and Unicode

Total characters	17
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	33.3%

Sample

1st row	0.034
2nd row	0.034
3rd row	0.01699

Common Values

Value	Count	Frequency (%)
0.034	2	6.5%
0.01699	1	3.2%
(Missing)	28	90.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.034	2	66.7%
0.01699	1	33.3%

Most occurring characters

Value	Count	Frequency (%)
0	6	35.3%
.	3	17.6%
3	2	11.8%
4	2	11.8%
9	2	11.8%
1	1	5.9%
6	1	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	6	35.3%
.	3	17.6%
3	2	11.8%
4	2	11.8%
9	2	11.8%
1	1	5.9%
6	1	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	6	35.3%
.	3	17.6%
3	2	11.8%
4	2	11.8%
9	2	11.8%
1	1	5.9%
6	1	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	6	35.3%
.	3	17.6%
3	2	11.8%
4	2	11.8%
9	2	11.8%
1	1	5.9%
6	1	5.9%

price_participants_7
Categorical

HIGH CORRELATION MISSING UNIFORM

Distinct	2
Distinct (%)	100.0%
Missing	29
Missing (%)	93.5%
Memory size	1.2 KiB

0.9993156095718888	1
0.06256	1

Length

Max length	18
Median length	12.5
Mean length	12.5
Min length	7

Characters and Unicode

Total characters	25
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	100.0%

Sample

1st row	0.9993156095718888
2nd row	0.06256

Common Values

Value	Count	Frequency (%)
0.9993156095718888	1	3.2%
0.06256	1	3.2%
(Missing)	29	93.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.9993156095718888	1	50.0%
0.06256	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
0	4	16.0%
9	4	16.0%
8	4	16.0%
5	3	12.0%
6	3	12.0%
.	2	8.0%
1	2	8.0%
3	1	4.0%
7	1	4.0%
2	1	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4	16.0%
9	4	16.0%
8	4	16.0%
5	3	12.0%
6	3	12.0%
.	2	8.0%
1	2	8.0%
3	1	4.0%
7	1	4.0%
2	1	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4	16.0%
9	4	16.0%
8	4	16.0%
5	3	12.0%
6	3	12.0%
.	2	8.0%
1	2	8.0%
3	1	4.0%
7	1	4.0%
2	1	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4	16.0%
9	4	16.0%
8	4	16.0%
5	3	12.0%
6	3	12.0%
.	2	8.0%
1	2	8.0%
3	1	4.0%
7	1	4.0%
2	1	4.0%

price_participants_8
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	30
Missing (%)	96.8%
Memory size	1.1 KiB

0.038	1

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	5
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	0.038

Common Values

Value	Count	Frequency (%)
0.038	1	3.2%
(Missing)	30	96.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.038	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
3	1	20.0%
8	1	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
3	1	20.0%
8	1	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
3	1	20.0%
8	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2	40.0%
.	1	20.0%
3	1	20.0%
8	1	20.0%

published_date
Date

UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Minimum	2013-04-29 00:00:00
Maximum	2023-10-24 00:00:00

Histogram

Histogram with fixed size bins (bins=31)

published_date_month
Date

Distinct	25
Distinct (%)	80.6%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Minimum	2013-04-01 00:00:00
Maximum	2023-10-01 00:00:00

Histogram

Histogram with fixed size bins (bins=25)

quantity_total
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120975.91

Minimum	2680.6392
Maximum	1179786.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	2680.6392
5-th percentile	4523.9721
Q1	8929.6623
median	32966.511
Q3	66229.464
95-th percentile	660411.6
Maximum	1179786.6
Range	1177106
Interquartile range (IQR)	57299.802

Descriptive statistics

Standard deviation	270300.25
Coefficient of variation (CV)	2.2343312
Kurtosis	11.235017
Mean	120975.91
Median Absolute Deviation (MAD)	25066.171
Skewness	3.4170952
Sum	3750253.2
Variance	7.3062224 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
32966.51108	1	3.2%
66527.92798	1	3.2%
5758.720773	1	3.2%
30548.84441	1	3.2%
6263.290169	1	3.2%
56479.37121	1	3.2%
160968.9444	1	3.2%
95007.35275	1	3.2%
1179786.644	1	3.2%
36740.26825	1	3.2%
Other values (21)	21	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2680.639219	1	3.2%
3289.22341	1	3.2%
5758.720773	1	3.2%
5900.676494	1	3.2%
6263.290169	1	3.2%
8426.467693	1	3.2%
8589.313285	1	3.2%
8833.156207	1	3.2%
9026.16847	1	3.2%
10766.58581	1	3.2%

Value	Count	Frequency (%)
1179786.644	1	3.2%
1018263.113	1	3.2%
302560.0861	1	3.2%
220249.4427	1	3.2%
160968.9444	1	3.2%
109912.3512	1	3.2%
95007.35275	1	3.2%
66527.92798	1	3.2%
65931.00078	1	3.2%
63904.29401	1	3.2%

region
Text

Distinct	16
Distinct (%)	51.6%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

Length

Max length	9
Median length	8
Mean length	8.3225806
Min length	8

Characters and Unicode

Total characters	258
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	19.4%

Sample

1st row	region_1
2nd row	region_2
3rd row	region_3
4th row	region_4
5th row	region_5

Value	Count	Frequency (%)
region_2	3	9.7%
region_5	3	9.7%
region_6	3	9.7%
region_8	3	9.7%
region_11	3	9.7%
region_3	2	6.5%
region_4	2	6.5%
region_7	2	6.5%
region_9	2	6.5%
region_12	2	6.5%
Other values (6)	6	19.4%

Most occurring characters

Value	Count	Frequency (%)
r	31	12.0%
g	31	12.0%
i	31	12.0%
o	31	12.0%
n	31	12.0%
_	31	12.0%
e	31	12.0%
1	14	5.4%
2	5	1.9%
5	4	1.6%
Other values (7)	18	7.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	258	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	31	12.0%
g	31	12.0%
i	31	12.0%
o	31	12.0%
n	31	12.0%
_	31	12.0%
e	31	12.0%
1	14	5.4%
2	5	1.9%
5	4	1.6%
Other values (7)	18	7.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	258	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	31	12.0%
g	31	12.0%
i	31	12.0%
o	31	12.0%
n	31	12.0%
_	31	12.0%
e	31	12.0%
1	14	5.4%
2	5	1.9%
5	4	1.6%
Other values (7)	18	7.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	258	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	31	12.0%
g	31	12.0%
i	31	12.0%
o	31	12.0%
n	31	12.0%
_	31	12.0%
e	31	12.0%
1	14	5.4%
2	5	1.9%
5	4	1.6%
Other values (7)	18	7.0%

second_place
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	25.8%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

N/A	16
participants_23	7
participants_7	2
participants_19	2
participants_6	1
Other values (3)	3

Length

Max length	15
Median length	3
Mean length	8.6451613
Min length	3

Characters and Unicode

Total characters	268
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	12.9%

Sample

1st row	N/A
2nd row	N/A
3rd row	participants_23
4th row	N/A
5th row	N/A

Common Values

Value	Count	Frequency (%)
N/A	16	51.6%
participants_23	7	22.6%
participants_7	2	6.5%
participants_19	2	6.5%
participants_6	1	3.2%
participants_4	1	3.2%
participants_8	1	3.2%
participants_16	1	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n/a	16	51.6%
participants_23	7	22.6%
participants_7	2	6.5%
participants_19	2	6.5%
participants_6	1	3.2%
participants_4	1	3.2%
participants_8	1	3.2%
participants_16	1	3.2%

Most occurring characters

Value	Count	Frequency (%)
p	30	11.2%
a	30	11.2%
t	30	11.2%
i	30	11.2%
N	16	6.0%
A	16	6.0%
/	16	6.0%
n	15	5.6%
_	15	5.6%
s	15	5.6%
Other values (10)	55	20.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	268	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	30	11.2%
a	30	11.2%
t	30	11.2%
i	30	11.2%
N	16	6.0%
A	16	6.0%
/	16	6.0%
n	15	5.6%
_	15	5.6%
s	15	5.6%
Other values (10)	55	20.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	268	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	30	11.2%
a	30	11.2%
t	30	11.2%
i	30	11.2%
N	16	6.0%
A	16	6.0%
/	16	6.0%
n	15	5.6%
_	15	5.6%
s	15	5.6%
Other values (10)	55	20.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	268	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	30	11.2%
a	30	11.2%
t	30	11.2%
i	30	11.2%
N	16	6.0%
A	16	6.0%
/	16	6.0%
n	15	5.6%
_	15	5.6%
s	15	5.6%
Other values (10)	55	20.5%

second_place_outcome
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Memory size	2.0 KiB

N/A	16
lost	14
won	1

Length

Max length	4
Median length	3
Mean length	3.4516129
Min length	3

Characters and Unicode

Total characters	107
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	3.2%

Sample

1st row	N/A
2nd row	N/A
3rd row	lost
4th row	N/A
5th row	N/A

Common Values

Value	Count	Frequency (%)
N/A	16	51.6%
lost	14	45.2%
won	1	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n/a	16	51.6%
lost	14	45.2%
won	1	3.2%

Most occurring characters

Value	Count	Frequency (%)
N	16	15.0%
/	16	15.0%
A	16	15.0%
o	15	14.0%
l	14	13.1%
s	14	13.1%
t	14	13.1%
w	1	0.9%
n	1	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	107	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	16	15.0%
/	16	15.0%
A	16	15.0%
o	15	14.0%
l	14	13.1%
s	14	13.1%
t	14	13.1%
w	1	0.9%
n	1	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	107	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	16	15.0%
/	16	15.0%
A	16	15.0%
o	15	14.0%
l	14	13.1%
s	14	13.1%
t	14	13.1%
w	1	0.9%
n	1	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	107	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	16	15.0%
/	16	15.0%
A	16	15.0%
o	15	14.0%
l	14	13.1%
s	14	13.1%
t	14	13.1%
w	1	0.9%
n	1	0.9%

second_place_price
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	13
Distinct (%)	86.7%
Missing	16
Missing (%)	51.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.16331561

Minimum	0.01571
Maximum	0.99931561
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	0.01571
5-th percentile	0.021653
Q1	0.034
median	0.04214
Q3	0.066565
95-th percentile	0.90639262
Maximum	0.99931561
Range	0.98360561
Interquartile range (IQR)	0.032565

Descriptive statistics

Standard deviation	0.31396596
Coefficient of variation (CV)	1.9224492
Kurtosis	4.5539134
Mean	0.16331561
Median Absolute Deviation (MAD)	0.02042
Skewness	2.4205926
Sum	2.4497341
Variance	0.098574624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0.034	2	6.5%
0.06511	2	6.5%
0.07071	1	3.2%
0.04214	1	3.2%
0.06802	1	3.2%
0.0242	1	3.2%
0.9993156096	1	3.2%
0.8665684756	1	3.2%
0.038	1	3.2%
0.03929	1	3.2%
Other values (3)	3	9.7%
(Missing)	16	51.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01571	1	3.2%
0.0242	1	3.2%
0.025	1	3.2%
0.034	2	6.5%
0.038	1	3.2%
0.03929	1	3.2%
0.04214	1	3.2%
0.06256	1	3.2%
0.06511	2	6.5%
0.06802	1	3.2%

Value	Count	Frequency (%)
0.9993156096	1	3.2%
0.8665684756	1	3.2%
0.07071	1	3.2%
0.06802	1	3.2%
0.06511	2	6.5%
0.06256	1	3.2%
0.04214	1	3.2%
0.03929	1	3.2%
0.038	1	3.2%
0.034	2	6.5%

sku
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	2.5 KiB

molecule_x_10mg_tablet	31

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	682
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	molecule_x_10mg_tablet
2nd row	molecule_x_10mg_tablet
3rd row	molecule_x_10mg_tablet
4th row	molecule_x_10mg_tablet
5th row	molecule_x_10mg_tablet

Common Values

Value	Count	Frequency (%)
molecule_x_10mg_tablet	31	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
molecule_x_10mg_tablet	31	100.0%

Most occurring characters

Value	Count	Frequency (%)
l	93	13.6%
e	93	13.6%
_	93	13.6%
m	62	9.1%
t	62	9.1%
o	31	4.5%
c	31	4.5%
u	31	4.5%
x	31	4.5%
1	31	4.5%
Other values (4)	124	18.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	93	13.6%
e	93	13.6%
_	93	13.6%
m	62	9.1%
t	62	9.1%
o	31	4.5%
c	31	4.5%
u	31	4.5%
x	31	4.5%
1	31	4.5%
Other values (4)	124	18.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	93	13.6%
e	93	13.6%
_	93	13.6%
m	62	9.1%
t	62	9.1%
o	31	4.5%
c	31	4.5%
u	31	4.5%
x	31	4.5%
1	31	4.5%
Other values (4)	124	18.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	682	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	93	13.6%
e	93	13.6%
_	93	13.6%
m	62	9.1%
t	62	9.1%
o	31	4.5%
c	31	4.5%
u	31	4.5%
x	31	4.5%
1	31	4.5%
Other values (4)	124	18.2%

start_date
Date

Distinct	30
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Minimum	2013-05-17 00:00:00
Maximum	2023-09-26 00:00:00

Histogram

Histogram with fixed size bins (bins=30)

winner
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Memory size	2.3 KiB

participants_16	16
participants_19	12
participants_6	2
participants_23	1

Length

Max length	15
Median length	15
Mean length	14.935484
Min length	14

Characters and Unicode

Total characters	463
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	3.2%

Sample

1st row	participants_16
2nd row	participants_16
3rd row	participants_16
4th row	participants_16
5th row	participants_16

Common Values

Value	Count	Frequency (%)
participants_16	16	51.6%
participants_19	12	38.7%
participants_6	2	6.5%
participants_23	1	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
participants_16	16	51.6%
participants_19	12	38.7%
participants_6	2	6.5%
participants_23	1	3.2%

Most occurring characters

Value	Count	Frequency (%)
p	62	13.4%
a	62	13.4%
t	62	13.4%
i	62	13.4%
r	31	6.7%
c	31	6.7%
n	31	6.7%
s	31	6.7%
_	31	6.7%
1	28	6.0%
Other values (4)	32	6.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	463	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	62	13.4%
a	62	13.4%
t	62	13.4%
i	62	13.4%
r	31	6.7%
c	31	6.7%
n	31	6.7%
s	31	6.7%
_	31	6.7%
1	28	6.0%
Other values (4)	32	6.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	463	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	62	13.4%
a	62	13.4%
t	62	13.4%
i	62	13.4%
r	31	6.7%
c	31	6.7%
n	31	6.7%
s	31	6.7%
_	31	6.7%
1	28	6.0%
Other values (4)	32	6.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	463	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	62	13.4%
a	62	13.4%
t	62	13.4%
i	62	13.4%
r	31	6.7%
c	31	6.7%
n	31	6.7%
s	31	6.7%
_	31	6.7%
1	28	6.0%
Other values (4)	32	6.9%

winner_price
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	80.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.016299677

Minimum	1 × 10^-5
Maximum	0.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	1 × 10^-5
5-th percentile	1 × 10^-5
Q1	0.01225
median	0.01699
Q3	0.02
95-th percentile	0.0345
Maximum	0.05
Range	0.04999
Interquartile range (IQR)	0.00775

Descriptive statistics

Standard deviation	0.011421468
Coefficient of variation (CV)	0.70071742
Kurtosis	1.4072859
Mean	0.016299677
Median Absolute Deviation (MAD)	0.00449
Skewness	0.66374969
Sum	0.50529
Variance	0.00013044993
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
0.02	3	9.7%
0.01786	2	6.5%
0.015	2	6.5%
0.0004	1	3.2%
0.02393	1	3.2%
0.0122	1	3.2%
0.018	1	3.2%
0.0123	1	3.2%
0.0205	1	3.2%
Other values (15)	15	48.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1 × 10^-5	3	9.7%
5 × 10^-5	1	3.2%
0.0001	1	3.2%
0.0004	1	3.2%
0.007	1	3.2%
0.0122	1	3.2%
0.0123	1	3.2%
0.0125	1	3.2%
0.014	1	3.2%
0.015	2	6.5%

Value	Count	Frequency (%)
0.05	1	3.2%
0.035	1	3.2%
0.034	1	3.2%
0.03	1	3.2%
0.025	1	3.2%
0.02393	1	3.2%
0.0205	1	3.2%
0.02	3	9.7%
0.019	1	3.2%
0.018	1	3.2%

duration_total_new
Real number (ℝ)

HIGH CORRELATION

Distinct	17
Distinct (%)	54.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.387097

Minimum	15
Maximum	74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	15
5-th percentile	16.5
Q1	30
median	42
Q3	48.5
95-th percentile	64.5
Maximum	74
Range	59
Interquartile range (IQR)	18.5

Descriptive statistics

Standard deviation	14.48143
Coefficient of variation (CV)	0.34990206
Kurtosis	-0.16990186
Mean	41.387097
Median Absolute Deviation (MAD)	7
Skewness	-0.00042106842
Sum	1283
Variance	209.71183
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
48	6	19.4%
42	4	12.9%
36	3	9.7%
49	2	6.5%
15	2	6.5%
30	2	6.5%
24	2	6.5%
62	1	3.2%
46	1	3.2%
56	1	3.2%
Other values (7)	7	22.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15	2	6.5%
18	1	3.2%
24	2	6.5%
26	1	3.2%
29	1	3.2%
30	2	6.5%
36	3	9.7%
42	4	12.9%
46	1	3.2%
48	6	19.4%

Value	Count	Frequency (%)
74	1	3.2%
67	1	3.2%
62	1	3.2%
56	1	3.2%
54	1	3.2%
51	1	3.2%
49	2	6.5%
48	6	19.4%
46	1	3.2%
42	4	12.9%

quantity_monthly
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3076.0968

Minimum	91
Maximum	28285
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	91
5-th percentile	176
Q1	272
median	1273
Q3	2254.5
95-th percentile	15190
Maximum	28285
Range	28194
Interquartile range (IQR)	1982.5

Descriptive statistics

Standard deviation	6349.047
Coefficient of variation (CV)	2.0639946
Kurtosis	11.693128
Mean	3076.0968
Median Absolute Deviation (MAD)	1028
Skewness	3.483059
Sum	95359
Variance	40310398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
845	1	3.2%
2772	1	3.2%
240	1	3.2%
1273	1	3.2%
522	1	3.2%
2353	1	3.2%
3354	1	3.2%
1979	1	3.2%
24077	1	3.2%
1021	1	3.2%
Other values (21)	21	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
91	1	3.2%
164	1	3.2%
188	1	3.2%
223	1	3.2%
234	1	3.2%
239	1	3.2%
240	1	3.2%
245	1	3.2%
299	1	3.2%
522	1	3.2%

Value	Count	Frequency (%)
28285	1	3.2%
24077	1	3.2%
6303	1	3.2%
4589	1	3.2%
3354	1	3.2%
3053	1	3.2%
2772	1	3.2%
2353	1	3.2%
2156	1	3.2%
1979	1	3.2%

quantity_yearly
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36913.161

Minimum	1092
Maximum	339420
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	1092
5-th percentile	2112
Q1	3264
median	15276
Q3	27054
95-th percentile	182280
Maximum	339420
Range	338328
Interquartile range (IQR)	23790

Descriptive statistics

Standard deviation	76188.564
Coefficient of variation (CV)	2.0639946
Kurtosis	11.693128
Mean	36913.161
Median Absolute Deviation (MAD)	12336
Skewness	3.483059
Sum	1144308
Variance	5.8046973 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
10140	1	3.2%
33264	1	3.2%
2880	1	3.2%
15276	1	3.2%
6264	1	3.2%
28236	1	3.2%
40248	1	3.2%
23748	1	3.2%
288924	1	3.2%
12252	1	3.2%
Other values (21)	21	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1092	1	3.2%
1968	1	3.2%
2256	1	3.2%
2676	1	3.2%
2808	1	3.2%
2868	1	3.2%
2880	1	3.2%
2940	1	3.2%
3588	1	3.2%
6264	1	3.2%

Value	Count	Frequency (%)
339420	1	3.2%
288924	1	3.2%
75636	1	3.2%
55068	1	3.2%
40248	1	3.2%
36636	1	3.2%
33264	1	3.2%
28236	1	3.2%
25872	1	3.2%
23748	1	3.2%

quantity_ext
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	31
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	140045.23

Minimum	3822
Maximum	1357680
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	3822
5-th percentile	4887
Q1	12092
median	41405
Q3	88677
95-th percentile	750613
Maximum	1357680
Range	1353858
Interquartile range (IQR)	76585

Descriptive statistics

Standard deviation	310195.15
Coefficient of variation (CV)	2.2149641
Kurtosis	11.506011
Mean	140045.23
Median Absolute Deviation (MAD)	32221
Skewness	3.4655929
Sum	4341402
Variance	9.6221034 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
41405	1	3.2%
72072	1	3.2%
5760	1	3.2%
61104	1	3.2%
12528	1	3.2%
70590	1	3.2%
181116	1	3.2%
94992	1	3.2%
1179773	1	3.2%
36756	1	3.2%
Other values (21)	21	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3822	1	3.2%
4014	1	3.2%
5760	1	3.2%
8424	1	3.2%
8820	1	3.2%
9184	1	3.2%
10038	1	3.2%
11656	1	3.2%
12528	1	3.2%
20033	1	3.2%

Value	Count	Frequency (%)
1357680	1	3.2%
1179773	1	3.2%
321453	1	3.2%
220272	1	3.2%
181116	1	3.2%
128226	1	3.2%
94992	1	3.2%
89466	1	3.2%
87888	1	3.2%
74550	1	3.2%

duration_ext
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.9677419

Minimum	0
Maximum	31
Zeros	7
Zeros (%)	22.6%
Negative	0
Negative (%)	0.0%
Memory size	380.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.5
median	6
Q3	12
95-th percentile	25
Maximum	31
Range	31
Interquartile range (IQR)	9.5

Descriptive statistics

Standard deviation	8.084899
Coefficient of variation (CV)	1.0147039
Kurtosis	1.5174712
Mean	7.9677419
Median Absolute Deviation (MAD)	6
Skewness	1.3643223
Sum	247
Variance	65.365591
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	8	25.8%
0	7	22.6%
12	4	12.9%
3	3	9.7%
10	2	6.5%
20	1	3.2%
14	1	3.2%
31	1	3.2%
26	1	3.2%
2	1	3.2%
Other values (2)	2	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	22.6%
2	1	3.2%
3	3	9.7%
5	1	3.2%
6	8	25.8%
10	2	6.5%
12	4	12.9%
14	1	3.2%
20	1	3.2%
24	1	3.2%

Value	Count	Frequency (%)
31	1	3.2%
26	1	3.2%
24	1	3.2%
20	1	3.2%
14	1	3.2%
12	4	12.9%
10	2	6.5%
6	8	25.8%
5	1	3.2%
3	3	9.7%

end_date
Date

Distinct	29
Distinct (%)	93.5%
Missing	0
Missing (%)	0.0%
Memory size	380.0 B

Minimum	2015-01-01 00:00:00
Maximum	2026-09-26 00:00:00

Histogram

Histogram with fixed size bins (bins=29)

Auto

Heatmap
Table

	contract_id	contract_type	duration	duration_ext	duration_total_new	maximum_price_allowed	outcome	participants_no	price_participants_16	price_participants_19	price_participants_23	price_participants_6	price_participants_7	quantity_ext	quantity_monthly	quantity_total	quantity_yearly	second_place	second_place_outcome	second_place_price	winner	winner_price
contract_id	1.000	0.000	-0.095	-0.213	-0.168	0.249	0.107	0.000	0.610	-0.357	-0.393	0.000	1.000	0.252	0.318	0.247	0.318	0.061	0.163	-0.376	0.579	0.213
contract_type	0.000	1.000	0.188	0.093	0.173	-0.067	0.000	0.000	-0.105	0.236	0.175	1.000	1.000	-0.158	-0.249	-0.224	-0.249	0.000	0.000	-0.227	0.000	-0.171
duration	-0.095	0.188	1.000	-0.016	0.830	0.060	0.076	0.034	0.178	0.359	0.271	1.000	1.000	0.458	0.215	0.490	0.215	0.000	0.000	-0.032	0.000	0.298
duration_ext	-0.213	0.093	-0.016	1.000	0.478	-0.067	0.891	0.000	-0.090	0.028	-0.198	0.000	1.000	-0.035	-0.251	-0.164	-0.251	0.213	0.599	-0.353	0.436	0.140
duration_total_new	-0.168	0.173	0.830	0.478	1.000	-0.023	0.000	0.391	0.087	0.459	-0.078	0.000	1.000	0.383	0.082	0.344	0.082	0.239	0.146	-0.239	0.000	0.349
maximum_price_allowed	0.249	-0.067	0.060	-0.067	-0.023	1.000	0.000	0.140	0.782	0.726	0.880	1.000	1.000	0.029	-0.020	0.062	-0.020	0.517	0.000	0.832	0.000	0.731
outcome	0.107	0.000	0.076	0.891	0.000	0.000	1.000	0.122	NaN	-0.310	0.394	1.000	1.000	-0.041	0.000	0.041	0.000	0.509	0.983	0.217	0.965	-0.204
participants_no	0.000	0.000	0.034	0.000	0.391	0.140	0.122	1.000	0.742	0.339	0.507	0.000	1.000	-0.113	-0.103	-0.085	-0.103	0.663	0.687	0.012	0.284	0.442
price_participants_16	0.610	-0.105	0.178	-0.090	0.087	0.782	NaN	0.742	1.000	-0.368	0.466	1.000	1.000	0.029	-0.015	0.042	-0.015	0.341	0.586	-0.106	0.588	0.706
price_participants_19	-0.357	0.236	0.359	0.028	0.459	0.726	-0.310	0.339	-0.368	1.000	0.085	0.000	NaN	0.077	-0.090	0.117	-0.090	0.289	0.000	0.489	0.957	0.974
price_participants_23	-0.393	0.175	0.271	-0.198	-0.078	0.880	0.394	0.507	0.466	0.085	1.000	0.000	NaN	-0.165	-0.274	0.011	-0.274	0.176	0.000	0.887	0.000	-0.229
price_participants_6	0.000	1.000	1.000	0.000	0.000	1.000	1.000	0.000	1.000	0.000	0.000	1.000	0.000	0.866	0.866	0.866	0.866	0.000	1.000	-0.866	0.000	0.866
price_participants_7	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	NaN	NaN	0.000	1.000	-1.000	-1.000	-1.000	-1.000	1.000	1.000	1.000	1.000	1.000
quantity_ext	0.252	-0.158	0.458	-0.035	0.383	0.029	-0.041	-0.113	0.029	0.077	-0.165	0.866	-1.000	1.000	0.933	0.980	0.933	0.000	0.000	-0.072	0.250	0.218
quantity_monthly	0.318	-0.249	0.215	-0.251	0.082	-0.020	0.000	-0.103	-0.015	-0.090	-0.274	0.866	-1.000	0.933	1.000	0.939	1.000	0.000	0.000	-0.029	0.271	0.088
quantity_total	0.247	-0.224	0.490	-0.164	0.344	0.062	0.041	-0.085	0.042	0.117	0.011	0.866	-1.000	0.980	0.939	1.000	0.939	0.000	0.000	0.131	0.250	0.230
quantity_yearly	0.318	-0.249	0.215	-0.251	0.082	-0.020	0.000	-0.103	-0.015	-0.090	-0.274	0.866	-1.000	0.933	1.000	0.939	1.000	0.000	0.000	-0.029	0.271	0.088
second_place	0.061	0.000	0.000	0.213	0.239	0.517	0.509	0.663	0.341	0.289	0.176	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.731	0.050	0.324	0.473
second_place_outcome	0.163	0.000	0.000	0.599	0.146	0.000	0.983	0.687	0.586	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.731	1.000	-0.217	0.713	0.476
second_place_price	-0.376	-0.227	-0.032	-0.353	-0.239	0.832	0.217	0.012	-0.106	0.489	0.887	-0.866	1.000	-0.072	-0.029	0.131	-0.029	0.050	-0.217	1.000	0.000	-0.016
winner	0.579	0.000	0.000	0.436	0.000	0.000	0.965	0.284	0.588	0.957	0.000	0.000	1.000	0.250	0.271	0.250	0.271	0.324	0.713	0.000	1.000	0.227
winner_price	0.213	-0.171	0.298	0.140	0.349	0.731	-0.204	0.442	0.706	0.974	-0.229	0.866	1.000	0.218	0.088	0.230	0.088	0.473	0.476	-0.016	0.227	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	active_ingredient	atc	buyer	contract_id	contract_type	duration	end_date_extension	maximum_price_allowed	outcome	pack_strength	participants_no	price_participants_16	price_participants_19	price_participants_23	price_participants_24	price_participants_4	price_participants_5	price_participants_6	price_participants_7	price_participants_8	published_date	published_date_month	quantity_total	region	second_place	second_place_outcome	second_place_price	sku	start_date	winner	winner_price	duration_total_new	quantity_monthly	quantity_yearly	quantity_ext	duration_ext	end_date
0	molecule_x	C07AB07	buyer_1	1	regional	39	2017-06-30	0.00040	won	10mg	1	0.00040	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2013-05-16	2013-05-01	32966.511085	region_1	N/A	N/A	NaN	molecule_x_10mg_tablet	2013-05-24	participants_16	0.00040	49.0	845.0	10140.0	41405.0	10.0	2016-08-24
1	molecule_x	C07AB07	buyer_2	2	wide area	48	2017-06-30	0.00700	won	10mg	1	0.00700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2013-04-29	2013-04-01	220249.442660	region_2	N/A	N/A	NaN	molecule_x_10mg_tablet	2013-06-21	participants_16	0.00700	48.0	4589.0	55068.0	220272.0	0.0	2017-06-21
2	molecule_x	C07AB07	buyer_3	3	regional	12	2016-02-14	0.07071	won	10mg	2	0.01400	NaN	0.07071	NaN	NaN	NaN	NaN	NaN	NaN	2013-06-09	2013-06-01	2680.639219	region_3	participants_23	lost	0.07071	molecule_x_10mg_tablet	2014-08-14	participants_16	0.01400	18.0	223.0	2676.0	4014.0	6.0	2015-08-14
3	molecule_x	C07AB07	buyer_4	4	regional	36	2017-12-31	0.02500	won	10mg	1	0.02500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2013-05-04	2013-05-01	5900.676494	region_4	N/A	N/A	NaN	molecule_x_10mg_tablet	2013-05-17	participants_16	0.02500	56.0	164.0	1968.0	9184.0	20.0	2016-05-17
4	molecule_x	C07AB07	buyer_5	5	regional	36	2017-06-30	0.00001	won	10mg	1	0.00001	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2013-12-18	2013-12-01	3289.223410	region_5	N/A	N/A	NaN	molecule_x_10mg_tablet	2013-12-17	participants_16	0.00001	42.0	91.0	1092.0	3822.0	6.0	2016-12-17
5	molecule_x	C07AB07	buyer_6	6	regional	48	2019-04-20	0.01900	won	10mg	1	0.01900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2013-12-06	2013-12-01	9026.168470	region_6	N/A	N/A	NaN	molecule_x_10mg_tablet	2014-02-21	participants_16	0.01900	62.0	188.0	2256.0	11656.0	14.0	2018-02-21
6	molecule_x	C07AB07	buyer_7	7	regional	12	2015-03-31	0.00001	won	10mg	1	0.00001	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2014-02-24	2014-02-01	17282.313832	region_7	N/A	N/A	NaN	molecule_x_10mg_tablet	2014-01-01	participants_16	0.00001	15.0	1440.0	17280.0	21600.0	3.0	2015-01-01
7	molecule_x	C07AB07	buyer_8	8	regional	36	2018-03-22	0.08000	won	10mg	4	0.03000	NaN	0.04066	NaN	NaN	0.08	0.034	NaN	NaN	2014-03-08	2014-03-01	31951.791632	region_8	participants_6	lost	0.03400	molecule_x_10mg_tablet	2014-05-22	participants_16	0.03000	46.0	888.0	10656.0	40848.0	10.0	2017-05-22
8	molecule_x	C07AB07	buyer_9	9	regional	24	2016-11-29	0.00001	won	10mg	1	0.00001	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2014-03-18	2014-03-01	35013.918539	region_9	N/A	N/A	NaN	molecule_x_10mg_tablet	2014-05-30	participants_16	0.00001	30.0	1459.0	17508.0	43770.0	6.0	2016-05-30
9	molecule_x	C07AB07	buyer_10	10	regional	36	2020-03-31	0.00010	won	10mg	1	0.00010	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2014-09-07	2014-09-01	10766.585813	region_10	N/A	N/A	NaN	molecule_x_10mg_tablet	2014-08-31	participants_16	0.00010	67.0	299.0	3588.0	20033.0	31.0	2017-08-31

	active_ingredient	atc	buyer	contract_id	contract_type	duration	end_date_extension	maximum_price_allowed	outcome	pack_strength	participants_no	price_participants_16	price_participants_19	price_participants_23	price_participants_24	price_participants_4	price_participants_5	price_participants_6	price_participants_7	price_participants_8	published_date	published_date_month	quantity_total	region	second_place	second_place_outcome	second_place_price	sku	start_date	winner	winner_price	duration_total_new	quantity_monthly	quantity_yearly	quantity_ext	duration_ext	end_date
21	molecule_x	C07AB07	buyer_16	22	multi-region	24	2022-09-30	0.01250	won	10mg	1	NaN	0.0125	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2020-06-10	2020-06-01	5.175292e+04	region_5	N/A	N/A	NaN	molecule_x_10mg_tablet	2020-04-29	participants_19	0.01250	29.0	2156.0	25872.0	62524.0	5.0	2022-04-29
22	molecule_x	C07AB07	buyer_8	23	multi-region	36	2023-07-21	0.03929	won	10mg	3	NaN	0.0350	0.03929	NaN	NaN	NaN	NaN	NaN	0.038	2020-06-20	2020-06-01	3.674027e+04	region_8	participants_8	lost	0.03800	molecule_x_10mg_tablet	2020-07-22	participants_19	0.03500	36.0	1021.0	12252.0	36756.0	0.0	2023-07-22
23	molecule_x	C07AB07	buyer_2	24	regional	49	2024-12-25	0.03929	won	10mg	2	NaN	0.0205	0.03929	NaN	NaN	NaN	NaN	NaN	NaN	2020-10-11	2020-10-01	1.179787e+06	region_2	participants_23	lost	0.03929	molecule_x_10mg_tablet	2020-11-25	participants_19	0.02050	49.0	24077.0	288924.0	1179773.0	0.0	2024-12-25
24	molecule_x	C07AB07	buyer_17	25	regional	48	2025-05-19	0.01230	won	10mg	1	NaN	0.0123	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-06-09	2021-06-01	9.500735e+04	region_14	N/A	N/A	NaN	molecule_x_10mg_tablet	2021-05-20	participants_19	0.01230	48.0	1979.0	23748.0	94992.0	0.0	2025-05-20
25	molecule_x	C07AB07	buyer_12	26	regional	48	2026-01-05	0.01800	won	10mg	1	NaN	0.0180	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2021-07-09	2021-07-01	1.609689e+05	region_12	N/A	N/A	NaN	molecule_x_10mg_tablet	2021-07-05	participants_19	0.01800	54.0	3354.0	40248.0	181116.0	6.0	2025-07-05
26	molecule_x	C07AB07	buyer_18	27	multi-region	24	2024-09-30	0.01220	won	10mg	1	NaN	0.0122	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2022-03-19	2022-03-01	5.647937e+04	region_15	N/A	N/A	NaN	molecule_x_10mg_tablet	2022-03-31	participants_19	0.01220	30.0	2353.0	28236.0	70590.0	6.0	2024-03-31
27	molecule_x	C07AB07	buyer_19	28	regional	12	2024-08-03	0.01571	won	10mg	2	NaN	0.0150	0.01571	NaN	NaN	NaN	NaN	NaN	NaN	2022-07-02	2022-07-01	6.263290e+03	region_6	participants_23	lost	0.01571	molecule_x_10mg_tablet	2022-08-04	participants_19	0.01500	24.0	522.0	6264.0	12528.0	12.0	2023-08-04
28	molecule_x	C07AB07	buyer_16	29	regional	24	2026-06-16	0.03400	lost	10mg	2	NaN	0.0340	0.02393	NaN	NaN	NaN	NaN	NaN	NaN	2022-07-01	2022-07-01	3.054884e+04	region_16	participants_19	won	0.03400	molecule_x_10mg_tablet	2022-06-17	participants_23	0.02393	48.0	1273.0	15276.0	61104.0	24.0	2024-06-17
29	molecule_x	C07AB07	buyer_19	30	regional	24	2025-07-31	0.02679	won	10mg	3	0.025	0.0150	0.02679	NaN	NaN	NaN	NaN	NaN	NaN	2023-07-09	2023-07-01	5.758721e+03	region_6	participants_16	lost	0.02500	molecule_x_10mg_tablet	2023-08-01	participants_19	0.01500	24.0	240.0	2880.0	5760.0	0.0	2025-08-01
30	molecule_x	C07AB07	buyer_8	31	regional	36	2027-03-30	0.09286	won	10mg	4	0.080	0.0155	0.09286	NaN	NaN	NaN	NaN	0.06256	NaN	2023-10-24	2023-10-01	1.099124e+05	region_8	participants_7	lost	0.06256	molecule_x_10mg_tablet	2023-09-26	participants_19	0.01550	42.0	3053.0	36636.0	128226.0	6.0	2026-09-26

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)